package han.dao;

import han.pojo.Record;
import han.pojo.countRecord;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
    @authou HanDianWei
    @create  2020-10-28 15:38

*/
public interface RecordMapper {
    int deleteByPrimaryKey(@Param("p_id") int p_id);

    int insert(Record record);

    Record selectByPrimaryKey(@Param("p_id") int p_id);

    int updateByPrimaryKey(Record record);

    List<Record> queryRecord();

    List<Record> queryRecordByName(@Param("p_name") String p_name);

    List<Record> queryRecordByClass(@Param("p_class") String p_class);

    List<countRecord> countRecordByTime(@Param("ptime1") String ptime1,@Param("ptime2") String ptime2);

    List<countRecord> countRecordByWeek();
    List<countRecord> countRecordAll();

    List<countRecord> countRecordByClass();
}